USE [GESTION2]
GO

/****** Object:  StoredProcedure [dbo].[WASP_D0008_ORIGEN_DESTINO]    Script Date: 11/23/2011 17:31:11 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WASP_D0008_ORIGEN_DESTINO]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[WASP_D0008_ORIGEN_DESTINO]
GO

USE [GESTION2]
GO

/****** Object:  StoredProcedure [dbo].[WASP_D0008_ORIGEN_DESTINO]    Script Date: 11/23/2011 17:31:11 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		<JJ>
-- Create date: <02/08/2011>
-- Description:	<ORIGEN DESTINO> por corregir/confirmar
-- =============================================
CREATE PROCEDURE [dbo].[WASP_D0008_ORIGEN_DESTINO] 

AS
BEGIN

SELECT 
 rut,dv,nombre,AGCOLOC,nro_credito,inicio_cobertura,FIN_COBERTURA,NROCUOTAS,DIRTRABAJA,tlfonopen,NROCUOTAS
INTO seguro_proteccion FROM seguro_proteccion_temp

END

GO

